class CreateJobs < ActiveRecord::Migration
  def self.up
    create_table :jobs do |t|

      t.column :creator_user_id, :integer
      t.column :created_at, :datetime

      t.column :title, :string
      t.column :committee, :string
      t.column :reports_to, :string
      t.column :description, :text
      t.column :skills, :text

      t.column :job_start_deadline, :datetime
      t.column :committment_description, :text
      t.column :weekly_hours, :integer
      t.column :weeks, :integer

      t.column :other_requirements, :string
      t.column :compile_format_id, :integer

      t.column :private_notes, :text
      t.column :status_id, :integer 
    end
  end

  def self.down
    drop_table :jobs
  end
end
